Tip: When you define more than one filter, by default the join uses And, which narrows the results. However, if you add multiple filters on the same object Property (such as StateProvince), by default the filters join with an Or connective, which broadens the results. Therefore, to use the same object Property in an And join, create those filters separately. For example, to define a filter to obtain customer records in Texas and in Virginia, first create one filter (where StateProvince = TX) and then select Add Filter to define the second part (where StateProvince = VA).
■ A Multiple checkbox is visible when the filter Property contains a discrete drop-down list of values. Selecting this checkbox changes the Value selector from a simple drop-down list that enables you to select only one specific value to a multi-select control that enables you to select multiple values. The selected values are used as an Or comparison. See Defining a filter property with several values for more information.
Tip: Even if the Multiple checkbox is not visible, you can still manually specify multiple values for any filter property by entering a comma-delimited list of quoted values. For example, you could specify the following multiple values for a City property: "Toronto","Montreal","Calgary"
■ Require the user to provide at least one valid value: User must enter a valid filter value before the query can be run.